| |
4872 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 30 June 2022 04:36 «»
By: thiyagarajancs
Re: SENDGRID | Curl
…procedure vip_mail_service is
req utl_http.req;
res utl_http.resp;
url varchar2(4000) := 'https://api.sendgrid.com/v3/mail/send';
name varchar2(4000);
buffer varchar2(4000);
content varchar2(4000) := '{"personalizations":[{&…
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 03 February 2024 00:25 «»
By: aabunarr
oracle10g and utl_http
…; *
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-28750: unknown error
ORA-06512: at line 1
"
by defualt i setup a wallet by orapki
and still get error
please any help…
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 22 June 2022 03:47 «»
By: fixxxer
orapki: add crt and key to wallet
…bms_network_acl_admin.create_acl (acl => 'http.xml', description => 'HTTP Access', principal => 'MYUSERNAME', is_grant => TRUE, privilege => 'connect', start_date => null, end_date => null);
EXEC dbms_network_acl_admin.…
|
| 4 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 13:16 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…error:
DRG-11622: URL store: unknown HTTP error 3823243664 getting http://acedmvaultprd.inl.gov/edm23m/10881/10880871.docx
DRG-50857: oracle error in read_into_lobLocator
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS…
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 24 October 2022 04:57 «»
By: fixxxer
ORA-29005: The certificate is invalid
…19.12.0.0.0
I am trying to make a UTL_HTTP request to an application server. I have assigned the ACL to the user in question, with connect and resolve permissions. The certificate has been added to the oracle wallet.
If I run the below select (to …
|
| 6 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 11:52 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…('KJC_TEST_INDEX_2_NETWORK_PREF','NO_PROXY','http://www.example.com/index.html, http://acedmvaultprd.inl.gov, acedmvaultprd, acedmvaultprd.inl.gov');
END;
/
and changed the URL to the document to be this:http://acedmvaultprd.inl.gov/…
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 01 January 2023 05:01 «»
By: mape
xml error eurofxref-daily.xml
…?
The source of xml is from website => https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml
I inserted the xml into table T (xmltype datatype):
SELECT EXTRACTVALUE ( value ( tab ), '/ Cube / @ currency…
|
| 8 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 10:57 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…('KJC_TEST_INDEX_2_NETWORK_PREF','NO_PROXY','http://www.example.com/index.html');
END;
/
INSERT into KJC_TEST_INDEX_2 (assigned_id, text_content_url)
VALUES ('ABC-123', 'http://acedmvaultprd.inl.gov/edm22h…
|
| 9 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 August 2023 10:00 «»
By: kjcook
How to access URL's from your database that are accessible from your browser
…error:
DRG-11622: URL store: unknown HTTP error 2447200152 getting http://myHost/10880871.docx
DRG-50857: oracle error in read_into_lobLocator
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDML", line 2183
…
|
| 10 |
Forum: Forms «»
Posted on: Wed, 13 July 2022 02:27 «»
By: Michel Cadot
Re: .fmb to .txt
…
Your 6 latest topics:
http://www.orafaq.com/forum/m/685879/#msg_685879 ==> no feedback
http://www.orafaq.com/forum/m/685703/#msg_685703 ==> no feedback
http://www.orafaq.com/forum/m/685426/#msg_685426 ==> no feedback (you didn't get help …
|
| 11 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 20:50 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…ext_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.html')
/
COMMIT
/
BEGIN
ctx_ddl.set_attribute('KJC_TEST_INDEX_1_URL_DATASTORE',
&…
|
| 12 |
Forum: Text & interMedia «»
Posted on: Wed, 16 August 2023 17:12 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…('KJC_TEST_INDEX_2_NETWORK_PREF','NO_PROXY','http://www.example.com/index.html, http://acedmvaultprd.inl.gov, acedmvaultprd, acedmvaultprd.inl.gov');
END;
/
-- INSERT into KJC_TEST_INDEX_2 (assigned_id, text_content_url)
-- &…
|
| 13 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 19:48 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…ext_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.html')
/
COMMIT
/
BEGIN
ctx_ddl.set_attribute('KJC_TEST_INDEX_1_URL_DATASTORE',
&…
|
| 14 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 03:17 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…timeout of 3600 seconds and no_proxy and 'http://www.example.com/index.html'. The error on the dropping of the url_datastore is only because it had been previously dropped, so that can be ignored.
C##SCOTT@XE_21.3.0.0.0> commit;
…
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 08 September 2022 06:40 «»
By: skfaheem024
Consuming Rest API from PL/SQL using UTL_HTTP - body not recognized
…Hi,
I am new to this forum and consuming Rest API's using PL/SQL. I am trying to consume a rest service from pl/sql, but the server is not able to identify the request. The same request works from postman.. so no problem in the service, something with …
|
| 16 |
Forum: Performance Tuning «»
Posted on: Fri, 04 December 2009 19:18 «»
By: BlackSwan
SQL statement tuning
….
Samples
.....
http://www.orafaq.com/forum/t/205234/
.....
Post the EXPLAIN PLAN that Oracle uses to execute your SQL.
Run the following in SQL*Plus
If PLAN_TABLE does not …
|
| 17 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 17:43 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…the network datastore which uses UTL_HTTP package internally to access data from websites through HTTP.
begin
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$…
|
| 18 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 12:58 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…'NO_PROXY',
'http://www.example.com/index.html,
http://acedmvaultprd.inl.gov,
acedmvaultprd,
acedmvaultprd…
|
| 19 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 08:47 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…('KJC_TEST_INDEX_2_NETWORK_PREF','NO_PROXY','http://www.example.com/index.html');
END;
/
INSERT into KJC_TEST_INDEX_2 (assigned_id, text_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.html…
|
| 20 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:24 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…ctx_ddl.set_attribute('URL_PREF','NO_PROXY','http://www.example.com/index.html');
4 ctx_ddl.set_attribute('URL_PREF','Timeout','10');
5 END;
6 /
PL/SQL procedure successfully completed.
C##SCOTT@…
|
| 21 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:03 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…ET_ATTRIBUTE('KJC_TEST_INDEX_URL_DATASTORE','HTTP_PROXY', 'webcache-2.inel.gov:8080');
END;
/
INSERT into kjc_test_index (assigned_id, text_content_url)
VALUES ('MCP-135', 'file:///usr/edms/web/edm22h/10160/…
|
| 22 |
Forum: Text & interMedia «»
Posted on: Thu, 10 August 2023 23:55 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…bsp;2 VALUES ('MCP-135', ' http://www.example.com/index.html')
3 /
1 row created.
SCOTT@orcl_12.1.0.2.0> BEGIN
2 ctx_ddl.create_preference('URL_PREF','URL_DATASTORE');
3 &…
|
| 23 |
Forum: Reports & Discoverer «»
Posted on: Mon, 10 July 2023 02:46 «»
By: shahzaib_4vip@hotmail.com
Hyperlink report to report
…with its working fine the query is
http://192.168.0.113:8889/reports/rwservlet?userid=faizan/a@xe&server=rep60server&report=c:\farazoracle\10gReports\Ledger.rep &destype=CACHE&desformat=PDF¶mform=no&date_from=10-JUL-23&…
|
| 24 |
Forum: Backup & Recovery «»
Posted on: Fri, 21 April 2023 03:35 «»
By: Michel Cadot
Re: Oracle RMAN Backup API
…is not documented.
A description can be found in Morgan's Library
You can find examples of using it on the web, for instance:
http://www.orafaq.com/forum/mv/msg/57760/156152/#msg_156152
http://www.orafaq.com/maillist/oracle-l/2006/08/10/0447.htm…
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 01 January 2023 06:40 «»
By: Solomon Yakobson
Re: xml error eurofxref-daily.xml
…type('<gesmes:Envelope xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01" xmlns="http://www.ecb.int/vocabulary/2002-08-01/eurofxref">
<gesmes:subject>Reference rates</gesmes:subject>
<gesmes:Sender>
<…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 08 September 2022 09:07 «»
By: John Watson
Re: Consuming Rest API from PL/SQL using UTL_HTTP - body not recognized
…for me:orclz>
orclz> select utl_http.request('https://weatherapi-com.p.rapidapi.com/ip.json',wallet_path=>'file:c:\tmp\wallet') from dual;
UTL_HTTP.REQUEST('HTTPS://WEATHERAPI-COM.P.RAPIDAPI.COM/IP.JSON',WALLET_PATH=>'FILE:C:\TMP\WALLET…
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 10 June 2022 08:16 «»
By: jesuisantony
Sporadic Certification Validation Error While accessing the external portal
…and fix this permanently? What could be reason for this intermittent certificate error?
ORA-29273: HTTP request failed
ORA-29024:Certificate Validation Failure
ORA-06512: at "SYS.UTL_HTTP", line 1491
ORA-06512: at line 1
Regards,
Anton…
|
| 28 |
Forum: Marketplace «»
Posted on: Wed, 17 August 2016 09:46 «»
By: Michel Cadot
McDP: like expdp/impdp Data Pump programs and much more
… permission of the author you can contact on http://www.orafaq.com
You can post your comments, ask for improvements, report bugs... on the program at
http://www.orafaq.com/forum/t/201760/
This link also contains detailed explaination and many examples …
|
| 29 |
Forum: Marketplace «»
Posted on: Thu, 18 February 2016 12:02 «»
By: Michel Cadot
McTnsping: a tnsping-like program for Windows
… permission of the author you can contact on http://www.orafaq.com
You can post your comments, ask for improvements, report bugs... on the program at
http://www.orafaq.com/forum/t/200058/
I encourage you to subscribe to this topic (link at top of the …
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 17 September 2024 03:51 «»
By: fixxxer
Re: ORA-29005: The certificate is invalid
…this lol. So we were trying to make a UTL_HTTP request to an API endpoint. There were already a set of certificates stored in the wallet on Oracle server. I added another certificate for the API application. The request was failing with the certificate I …
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 04 February 2024 09:25 «»
By: Frank Naude
Re: oracle10g and utl_http
…assume it's an HTTPS and not a plain HTTP request that's failing.
The request is probably using a newer protocol that's not supported by your older 10g database.
$ oerr ora 28750
28750, 00000, "unknown error"
// *Cause: An …
|
| 32 |
Forum: Weblogic & Application Server «»
Posted on: Tue, 16 January 2024 02:51 «»
By: calacausi
Oracle Reports server 12c. "showjobsid" page does not close
…when we run a report, the showjobid (eg: http://serverURL:7777/reports/rwservlet/showjobid73?server=rep_wls_reports_srv&EnvId=DEFAULT&statusonly=true&autorefresh= 1&closewindow=yes) page does not close. after installation, we copied the …
|
| 33 |
Forum: Performance Tuning «»
Posted on: Sun, 31 December 2023 02:46 «»
By: Michel Cadot
Re: query output speed very slow
…any SQL performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
You can also read:
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL …
|
| 34 |
Forum: Security «»
Posted on: Wed, 18 October 2023 12:58 «»
By: John Watson
Re: Security & Encryption
…be transparent to your application. I've configured this for customers a few times, drop my boss a note if you'ld like any assistance.
--
John Watson
Oracle Certified Master DBA
Oracle Certified Professional OCI Architect
http://skillbuilders.com…
|
| 35 |
Forum: Networking and Gateways «»
Posted on: Wed, 27 September 2023 05:42 «»
By: muthukrish104
TNS-03505: Failed to resolve name from 12c client to 19c DB
…9C\APP\admin\*****\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "*****&…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 02 September 2023 15:09 «»
By: Barbara Boehmer
Re: Jaro-Winkler similarity for 9i
…bsp; -- from OraFAQ thread: http://www.orafaq.com/forum/mv/msg/164224/689059/#msg_689059
4 return number
5 authid definer
6 deterministic
7 as
&…
|
| 37 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 16:36 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…mple.dat file that contains the same data as http://www.example.com/index.html that I was previously accessing and put it in my c:\my_oracle_files operating system directory.
There are 2 scripts that need to be run. The first as sysdba to create…
|
| 38 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 18:28 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…_ATTRIBUTE('KJC_TEST_INDEX_1_URL_DATASTORE','HTTP_PROXY', 'webcache-2.inel.gov:8080');
END;
/
INSERT into KJC_TEST_INDEX_1 (assigned_id, text_content_url)
VALUES('MCP-135', 'file:///usr/edms/web/edm23m/10881/…
|
| 39 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 16:35 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…ET_ATTRIBUTE('KJC_TEST_INDEX_URL_DATASTORE','HTTP_PROXY', 'webcache-2.inel.gov:8080');
END;
/
INSERT into kjc_test_index (assigned_id, text_content_url)
VALUES('MCP-135', 'file:///usr/edms/web/edm23m/10881/10880871…
|
| 40 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 13:37 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…ET_ATTRIBUTE('KJC_TEST_INDEX_URL_DATASTORE','HTTP_PROXY', 'webcache-2.inel.gov:8080');
EXCEPTION
WHEN OTHERS THEN
…
|
Blog
Search
Help
Members
Register
Login
Home